<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>订单列表</title>
<link href="../css/css.css" type="text/css" rel="stylesheet" />
<link href="../css/main.css" type="text/css" rel="stylesheet" />
<link rel="shortcut icon" href="../images/main/favicon.ico" />
<style>
body{overflow-x:hidden; background:#f2f0f5; padding:15px 0px 10px 5px;}
#searchmain{ font-size:12px;}
#search{ font-size:12px; background:#548fc9; margin:10px 10px 0 0; display:inline; width:100%; color:#FFF; float:left}
#search form span{height:40px; line-height:40px; padding:0 0px 0 10px; float:left;}
#search form input.text-word{height:24px; line-height:24px; width:180px; margin:8px 0 6px 0; padding:0 0px 0 10px; float:left; border:1px solid #FFF;}
#search form input.text-but{height:24px; line-height:24px; width:55px; background:url(../images/main/list_input.jpg) no-repeat left top; border:none; cursor:pointer; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#666; float:left; margin:8px 0 0 6px; display:inline;}
#search a.add{ background:url(../images/main/add.jpg) no-repeat -3px 7px #548fc9; padding:0 10px 0 26px; height:40px; line-height:40px; font-size:14px; font-weight:bold; color:#FFF; float:right}
#search a:hover.add{ text-decoration:underline; color:#d2e9ff;}
#main-tab{ border:1px solid #eaeaea; background:#FFF; font-size:12px;}
#main-tab th{ font-size:12px; background:url(../images/main/list_bg.jpg) repeat-x; height:32px; line-height:32px;}
#main-tab td{ font-size:12px; line-height:40px;}
#main-tab td a{ font-size:12px; color:#548fc9;}
#main-tab td a:hover{color:#565656; text-decoration:underline;}
.bordertop{ border-top:1px solid #ebebeb}
.borderright{ border-right:1px solid #ebebeb}
.borderbottom{ border-bottom:1px solid #ebebeb}
.borderleft{ border-left:1px solid #ebebeb}
.gray{ color:#dbdbdb;}
td.fenye{ padding:10px 0 0 0; text-align:right;}
.bggray{ background:#f9f9f9}
</style>
</head>
<?php

 ?>
<body>
<!--main_top-->
<?php  ?>
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="searchmain">
  <tr>
    <td width="99%" align="left" valign="top">您的位置：订单管理</td>
  </tr>
  <tr>
    <td align="left" valign="top">
    <table width="100%" border="0" cellspacing="0" cellpadding="0" id="search">
  		<tr>
   		 <td width="90%" align="left" valign="middle">
	         <form method="get" action="goodslist.php">
	         <span>订单号：</span>
	         <input type="text" name="linkman" value="" class="text-word">
	         <input name="search" type="submit" value="查询" class="text-but">
	         </form>
         </td>
  		  <td width="10%" align="center" valign="middle" style="text-align:right; width:150px;"><a href="goodsadd.php" target="mainFrame" onFocus="this.blur()" class="add">新增</a></td>
  		</tr>
	</table>
    </td>
  </tr>
  <tr>
    <td align="left" valign="top">
    <table width="100%" border="0" cellspacing="0" cellpadding="0" id="main-tab">
      <tr>
        <th align="center" valign="middle" class="borderright">订单编号</th>
        <th align="center" valign="middle" class="borderright">会员ID号</th>
        <th align="center" valign="middle" class="borderright">商品名</th>
        <th align="center" valign="middle" class="borderright">联系人</th>
        <th align="center" valign="middle" class="borderright">单价</th>
        <th align="center" valign="middle" class="borderright">数量</th>
        <th align="center" valign="middle" class="borderright">总金额</th>
        <th align="center" valign="middle" class="borderright">购买时间</th>
        <th align="center" valign="middle" class="borderright">状态</th>
        <th align="center" valign="middle">操作</th>
      </tr>
	      <?php
		  //判断是否传递搜索值
		  if(isset($_GET['linkman'])){
			$where="where status in(2,3) and linkman like '%{$_GET['linkman']}%'";
			$url="&linkman={$_GET['linkman']}";
		  }else{
			$where='';
			$url='';
		  }
		  //判断页数
		  $nowpage=isset($_GET['page']) ? $_GET['page'] : 1;
		  $every=5;
		  $fir=($nowpage-1)*$every;
		  //限制上一页的边界
		  if($nowpage>1){
			$prevpage=$nowpage-1;
		  }else{
			$prevpage=1;
		  }
		//导入公共文件
		include('../../public/config.php');
		//连接数据库
		$con=@mysql_connect(HOST,USER,PASS) or die('连接数据库失败！');
		//选择数据库并设置字符集
		mysql_select_db(DBNAME,$con);
		mysql_set_charset('utf8');
		//编写sql语句
		$pagesql="select count(*) counts from orders {$where}";
		//判断有多少条记录
		$sqlres=mysql_query($pagesql);
		$sqlnum=mysql_fetch_assoc($sqlres)['counts'];
		$total=ceil($sqlnum/$every);
		//限制下一页的边界
		if($nowpage<$total){
			$nextpage=$nowpage+1;
		}else{
			$nextpage=$total;
		}
		//编写sql语句
		if($where){
			$sql="select o.linkman,o.address,o.phone,o.addtime,o.total,o.status,d.name,d.price,d.num from orders o,detail d {$where} and o.id=d.orderid limit {$fir},{$every}";
		}else{
			$sql="select o.id,o.uid,d.name,o.linkman,d.price,d.num,o.total,o.addtime,o.status from orders o,detail d where o.id=d.orderid and status in(2,3) limit {$fir},{$every}";
		}
		//var_dump($sql);die;
		//执行sql语句并解析结果集并遍历
		$result = mysql_query($sql);
	?>
      
	  <?php 		
		$i=1;
		if(empty($result)){
			echo "";
		}else{
		while($row = mysql_fetch_assoc($result)){
			if($i%2==1){ ?>
		<tr onMouseOut="this.style.backgroundColor='#ffffff'" onMouseOver="this.style.backgroundColor='#edf5ff'">
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['id']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['uid']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['name']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['linkman']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['price']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['num']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['total']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo date(Ymd,$row['addtime']); ?></td>
        <!--<td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['total']; ?></td>-->
        <td align="center" valign="middle" class="borderright borderbottom"><?php 
			switch($row['status']){
				case 2:
					echo '已收货';
					break;
				case 3:
					echo '无效订单';
					break;
			}
		?></td>
        <!--<td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['store']; ?></td>-->
        <td align="center" valign="middle" class="borderbottom"><a href="goodsedit.php?id=<?php echo $row['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">编辑</a><span class="gray">&nbsp;|&nbsp;</span><a href="doaction.php?a=doDel&id=<?php echo $row['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">删除</a></td>
      </tr>
	  <?php }else{ ?>
      <tr onMouseOut="this.style.backgroundColor='#ffffff'" onMouseOver="this.style.backgroundColor='#edf5ff'">
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['id']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['uid']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['name']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['linkman']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['price']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['num']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['total']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['addtime']; ?></td>
        <!--<td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['total']; ?></td>-->

        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['num']; ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php 
			switch($row['status']){
				case 2:
					echo '已收货';
					break;
				case 3:
					echo '无效订单';
					break;
				} ?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $row['store']; ?></td>
        <td align="center" valign="middle" class="borderbottom"><a href="goodsedit.php?id=<?php echo $row['id']; ?>" target="mainFrame" onFocus="this.blur()" class="add">编辑</a><span class="gray">&nbsp;|&nbsp;</span><a href="doaction.php?a=doDel&id=<?php echo $row['id'];?>" target="mainFrame" onFocus="this.blur()" class="add">删除</a></td>
      </tr>
	<?php 
		}
		$i++;
	}
  }?>
    </table>
	</td>
    </tr>
  <tr>
    <td align="left" valign="top" class="fenye"><?php echo $sqlnum ?>条数据 <?php echo"{$nowpage}/{$total}"?> 页&nbsp;&nbsp;
	<a href="goodslist.php?page=<?php $nowpage=1; echo $nowpage.$url; ?>" target="mainFrame" onFocus="this.blur()">首页</a>&nbsp;&nbsp;
	<?php echo "<a href='goodslist.php?page={$prevpage}{$url}' target='mainFrame' onFocus='this.blur()'>上一页</a>&nbsp;&nbsp;";?>
	<?php echo "<a href='goodslist.php?page={$nextpage}{$url}' target='mainFrame' onFocus='this.blur()'>下一页</a>&nbsp;&nbsp;";?>
	<a href="goodslist.php?page=<?php $nowpage=$total; echo $nowpage.$url;?>" target="mainFrame" onFocus="this.blur()">尾页</a></td>
  </tr>
</table>
</body>
</html>